import pandas as pd
import numpy as np
from bokeh.plotting import figure, show
from bokeh.io import curdoc, show, output_notebook
from bokeh.models import ColumnDataSource, HoverTool
output_notebook()
world_data = pd.read_csv('/home/jericho/country_profile_variables.csv')
world_data = world_data.set_index('country')
covid_data = pd.read_json('https://pomber.github.io/covid19/timeseries.json')
for country in world_data.index:
try:
world_data.loc[country, 'COVID19_confirmed'] = covid_data[country][328]['confirmed']
world_data.loc[country, 'COVID19_recovered'] = covid_data[country][328]['recovered']
world_data.loc[country, 'COVID19_deaths'] = covid_data[country][328]['deaths']
except KeyError:
pass
del world_data['Region']
for i in world_data.columns:
#create Figure
p = figure()
#create Scatter in Figure
exec("p.scatter(x='"+i+"', y='COVID19_deaths', marker='x', source=ColumnDataSource(world_data), line_color='#6666ee', fill_color='#ee6666', fill_alpha=0.5, size=12)")
#set x/y axis labels
exec("p.xaxis.axis_label = '"+i+"'")
p.yaxis.axis_label = 'COVID19_deaths'
#create Hover for Scatter
p_hover = HoverTool()
exec("p_hover.tooltips = [('Country', '@country'),('Deaths', '@COVID19_deaths')]")
p.add_tools(p_hover)
show(p)